• General information
  • About
  • Supported file formats
  • Key terms
• Interface overview
  • Screen elements
  • Command menu
  • Main menu
  • Toolbar
    • Change the display mode
    • Hide or display tool group titles
    • Hide or display the content of tool groups
    • Customize the composition of the Favorites group of tools
      • Add a button
      • Change a button to run a macro
      • Move an element
      • Delete an element
      • Clear the Favorites group
    • Hide or display the Favorites group
  • Range field
  • Formula bar
    • Input field
    • Сhange the height of the bar
  • Quick actions pane
  • Workspace
  • Sheet tabs
  • Sidebar
  • Status bar
  • Language
• Files
  • New file
  • Save as template
  • New from template
    • Automatic template selection
    • Select a template manually
  • Open a file
    • File in .xls format
    • File in .xlsb format
    • File in .xml format
    • View-only file
    • File is used by another application or user
  • Convert a file
  • Recent files
  • Send a file
  • Preview and print
    • Print document without opening the application
    • While working in the application
      • Select the print area
      • Print with presets
      • Page break parameters
      • Quick print
  • Save a file
    • Save as
    • Save
  • Autorecovery of documents
    • Configure autorecovery of documents
    • Document recovery
    • Recovered files pane
  • Close a file
• Sheets
  • Insert a sheet
  • Rename a sheet
  • Hide or unhide sheets
  • Duplicate a sheet
  • Change sheets order
  • Select a sheet from the list
  • Zoom a sheet
  • Hide or display zero values
  • Delete a sheet
• Cells, columns, and rows
  • Expand the workspace
  • Select cell ranges
  • Select colums or rows
  • Multiple selection
  • Resize cells
  • Resize a column or row
    • Change the size manually
    • Adjust automatically
    • Specify the exact size
  • Merge or unmerge cells
  • Insert columns or rows
  • Hide or unhide a column or row
  • Freeze columns, rows, or area
  • Group columns or rows
  • Delete columns or rows
• Data
  • Enter data
    • Enter data in a cell
    • Automatically adjust cell width
    • Floating cell
    • Autofill cells
    • Text formatting of formulas and numbers
  • Sort and filter
    • Define sort and filter range
    • Automatic detection of the sort and filter range
    • Sort
      • Single-level sorting
        • Sort by value
        • Sort by cell fill color
        • Sort by font color
      • Multi-level sorting
        • Create a multi-level sorting
        • Operations with levels
        • Edit a multi-level sorting
    • Filter
      • Filter by values
      • Filter by cell fill color
      • Filter by condition
        • Filter by date
        • Filter by numeric values
      • Reset all filters
    • Copy and paste filtered data
    • Refresh the filter
    • Finishing work with sorting and filtering range
  • Data validation
    • Add data validation
    • Edit data validation
    • Delete data validation
    • Actions with cells containing data validation
    • Enter a date
    • Enter a value in a cell with a drop-down list
  • Find and replace
  • Delete data
  • Remove duplicates
  • Links
    • Insert a link to a web page or email address
    • Insert a link to a place in the document
    • Insert a link to a file
    • Quick link insertion
    • Follow the link
    • Copy a link
    • Edit a link
    • Delete a link
    • Keyboard shortcuts for moving between window elements
  • Notes
    • Create a note
    • Edit a note
    • Delete notes
  • Special characters
    • Quick insert special characters pane
    • Special characters window
  • Current date or time
  • Spelling and grammar
    • Check spelling
    • Custom dictionary
    • Grammar check
• Number formats
  • Define cell format
  • Open number format settings window
  • General
  • Number
    • Split the number into digit groups
    • Change the number of decimal places
    • Customize negative number display style
  • Currency
    • Select a currency code or symbol
    • Change the number of decimal places
    • Customize negative number display style
  • Accounting
    • Select a currency code or symbol
    • Change the number of decimal places
  • Date, Time, and Date and time
    • Using formats in calculations
    • Change the date and/or time display format
  • Percentage
  • Fraction
  • Scientific
  • Text
• Formulas and functions
  • Formulas and functions basics
  • Order of operations in a formula
  • Reference cells and cell ranges
    • А1 cell reference style
    • R1C1 reference style
    • Cell range reference
  • Recalculation of formulas
    • Select formula recalculation mode
    • Recalculation of formulas in automatic mode
    • Recalculate formulas manually
    • Recalculate formulas when saving a document
  • Automatic calculation
  • Enter functions
    • Enter into a cell or the Formula bar
    • Enter using the Function pane
    • Autosum
  • Function wizard
    • View and edit formulas
    • View the structure of formulas
    • Specifics of work in the collaborative edit mode
  • Replace a formula with its result
  • Copy and insert formulas
  • Names in formulas and functions
    • Define name
    • Find a name
      • Find a name using the range field
      • Find using Name manager
    • Enter a name into formula or function
    • View name properties
    • Delete a name
  • Reference to data in another document
    • Create a reference with a mouse click
    • Enter the reference manually
    • Update data
  • Structured references
    • Use of structured references
    • Structured reference syntax
    • Enter a structured reference in a formula
• Calculation operators
  • Arithmetic operators
  • Comparison operators
  • Text concatenation operator 
  • Reference operators
• Tables
  • Create a table
  • Open the table settings pane
  • Customize the appearance
  • Rename the table
  • Automatic table expansion
  • Add a calculated column
  • Select the type of calculation in the total row
  • Convert a table to a regular range
  • Delete a table
• Pivot tables
  • Create a pivot table
    • Create a pivot table based on the data in the current file
    • Create a pivot table based on data from an external source
  • Open the pivot table settings pane
  • Define the structure of the pivot table
    • Add fields
    • Change the field order in a section
    • Rename a field
    • Select value calculation functions
      • Select a function for the main calculation
      • Select a function for additional calculation
    • Delete a pivot table field
  • Customize the pivot table parameters
    • Change the data source
    • Select the pivot table layout
    • Customize the display of grand totals
    • Customize the display of subtotals
    • Enable viewing of cell details
    • Edit captions
  • Manage external sources
    • View the list of external sources
    • View information about an external source
    • Change information about an external source
    • Add an external source
    • Delete an external source
  • Filter data in a pivot table
    • Filter data using the report filter
    • Filter rows and columns by values
    • Filter rows and columns by condition
    • Clear the filter
  • Sort data in a pivot table
  • Collapse or expand the elements of pivot table
  • View cell details
  • Refresh a pivot table
  • Copy a pivot table
  • Delete a pivot table
• Charts
  • Insert a chart
  • Open the chart settings pane
  • Chart settings
  • Open chart elements settings
  • Customize the appearance of an element
  • Customize element text formatting
  • Adjust the parameters of axes and gridlines
  • Hide or display an element
  • Move a chart
  • Copy, cut or insert a chart
  • Change chart type
  • Resize a chart
  • Change data in chart
  • Change the data range for the chart
  • Delete a chart or a chart element
• Images
  • Insert an image
    • Insert an image from computer
    • Insert image from browser or other editor
  • Replace an image
  • Resize an image
  • Move an image
  • Save an image
  • Delete an image
• Shapes
  • Insert a shape
    • Insert a line
    • Insert a shape
    • Insert a text box
  • Fill a shape
    • Fill a shape with color
    • Fill a shape with image
    • Remove the fill color
  • Outline
    • Select the color of the shape outline
    • Select the thickness and line type of the shape outline
    • Apply outline settings of the previous shape
    • Delete shape outline
  • Line style
    • Select a line color
    • Select the thickness and line type
    • Apply the style of the previous line
    • Reset the line style
  • Resize a shape
  • Fit shape size to text
  • Change line length and angle
  • Select arrowhead type
  • Move a shape
  • Delete a shape
• Format
  • Font
  • Font size
  • Font formatting
  • Font сolor
    • Choose a color from the color sets provided
    • Specify the color code manually
    • Copy the color with an eyedropper
  • Highlight color
  • Alignment
  • Rotate text
  • Wrap text
  • Character spacing
  • Cell fill color
    • Choose a color from the color sets provided
    • Specify the color code manually
    • Copy the color with an eyedropper
    • Remove the fill color
  • Cell borders
    • Choose a color from the color sets provided
    • Specify the color code manually
    • Copy the color with an eyedropper
    • Apply the last selected border style
    • Delete borders
  • Conditional formatting
    • Create a formatting rule
    • Clear formatting rules
  • Copy and apply formatting
    • Copy and paste formatting rules
    • Copy and apply formatting
    • Formatting history
  • Clear formatting
• Edit content
  • Undo and redo
  • Cut or copy data
  • Paste the last cut or copied data
    • Paste data while maintaining the original formatting
    • Paste data without preserving the original formatting
    • Paste data and transpose
  • Clipboard history
    • Paste data
    • Clear the clipboard history
• Cloud actions
  • Log in
  • Server connection indicator and server certificate
  • Create a file or folder
  • Open a file
  • Save the file to the cloud
  • Create a local copy
  • Upload a file
  • Download a file or folder
  • Delete a file
  • Restore a file or folder
  • Shared access to files
    • Share a file
    • Change sharing settings
    • Revoke access to files
  • Revoke own access
  • Log out
• Automation tools
  • Macros
    • Create a macro
    • Find a macro
    • Run a macro
    • Edit a macro
    • Debug a macro
    • Delete a macro
    • View VBA macro code
  • Extensions
    • Install an extension
    • Run an extension
    • Automatic disabling of extensions
    • Enable or disable the extension
    • Update the extension version
    • Remove an extension
• Document protection
  • Protect document with a password
    • Set a password
    • Change a password
    • Remove password
    • Open a document with a password
  • Protect content from changes
    • Protect a sheet
    • Protect the document structure
    • Unprotect a sheet
    • Unprotect sheet structure
• Keyboard shortcuts
• Education pane
• List of functions
  • SUBTOTAL function
• List of supported currencies